clear
set mem 500m
insheet using "C:\Documents and Settings\odaxs1\My Documents\NPD\Data Update\BEA_Jan05 - Dec05.csv"
rename months timeper 
rename subcategory subcat 
rename itemmodel modela 
rename itemdescription moddesc 
rename totalunitsprojected units 
rename unitpriceprojected unit_price
gen dollars = units*unit_price 
drop unit_price
rename allinone aio 
rename bluetooth bltooth 
rename displaysize dispsiz 
rename displaytype disptyp 
rename dvdformat dvdformt 
rename dvdreadwrite dvdrw 
rename pcfamily family 
rename flashdrivecapacity fldrcap 
rename pcform formpc 
rename graphicscontroller grcontr 
rename graphicscontrollerbrand grcrdbr 
rename graphicsmemory grmemory 
rename hdformfactor hdff 
rename harddriveincluded hdincld 
rename harddrivedisksize hdsize 
rename dvdincluded incdvd 
rename includeddrives incldrv 
rename integratedcamera integcam 
rename internalmemory intmem 
rename maximumprocessorcapability maxproc 
rename removablemedia media 
rename removablemediatype medtype 
rename nextgendvdtechnology ngenincl 
rename opsys os 
rename heightinches pcheight 
rename pctechnologyfamily pctecfam 
rename televisiontuner pctvtune 
rename weightlbs pcweight 
rename pcprocessorbrand procbran 
rename processorcore proccore 
rename pctechnology proctyp 
rename pcmemory rampc 
rename refurbished refurb 
rename screenfinish scrnfin 
rename screenformat scrnfor 
rename displayresolution scrnqul 
rename consumercommercial sector 
rename storagedrivetype stdrtype 
rename touchscreendisplay tchscrdi 
rename wirelesswan wlesswan 
rename wirelesstechnology wtech 
*rename dictionary_key 
*rename unit_price__projected_
*rename removable_media_handle_high_capa

save "C:\Documents and Settings\odaxs1\My Documents\NPD\Data Update\ofive", replace
clear
insheet using "C:\Documents and Settings\odaxs1\My Documents\NPD\Data Update\BEA_Oct04 - Dec04.csv"
rename months timeper 
rename subcategory subcat 
rename itemmodel modela 
rename itemdescription moddesc 
rename totalunitsprojected units 
rename totaldollarsprojected dollars 
rename allinone aio 
rename bluetooth bltooth 
rename displaysize dispsiz 
rename displaytype disptyp 
rename dvdformat dvdformt 
rename dvdreadwrite dvdrw 
rename pcfamily family 
rename flashdrivecapacity fldrcap 
rename pcform formpc 
rename graphicscontroller grcontr 
rename graphicscontrollerbrand grcrdbr 
rename graphicsmemory grmemory 
rename hdformfactor hdff 
rename harddriveincluded hdincld 
rename harddrivedisksize hdsize 
rename dvdincluded incdvd 
rename includeddrives incldrv 
rename integratedcamera integcam 
rename internalmemory intmem 
rename maximumprocessorcapability maxproc 
rename removablemedia media 
rename removablemediatype medtype 
rename nextgendvdtechnology ngenincl 
rename opsys os 
rename heightinches pcheight 
rename pctechnologyfamily pctecfam 
rename televisiontuner pctvtune 
rename weightlbs pcweight 
rename pcprocessorbrand procbran 
*rename processorcore proccore 
rename pctechnology proctyp 
rename pcmemory rampc 
rename refurbished refurb 
rename screenfinish scrnfin 
rename screenformat scrnfor 
rename displayresolution scrnqul 
rename consumercommercial sector 
*rename storagedrivetype stdrtype 
*rename touchscreendisplay tchscrdi 
rename wirelesswan wlesswan 
rename wirelesstechnology wtech 
*rename dictionary_key 
*rename unit_price__projected_
*rename removable_media_handle_high_capa
save "C:\Documents and Settings\odaxs1\My Documents\NPD\Data Update\ofour", replace
